SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwrOrganizacionesSF
AS
SELECT     idOrganizaciones AS ID, Nombre, CUISE, CUE, CAST(CUISE AS VARCHAR) + ' - ' + Nombre AS Descripcion, Tipo, EsPrivada
FROM         dbo.tb_Organizaciones
GO
GRANT SELECT ON  [dbo].[vwrOrganizacionesSF] TO [Becas]
GRANT SELECT ON  [dbo].[vwrOrganizacionesSF] TO [CentroDeDesignaciones]
GRANT SELECT ON  [dbo].[vwrOrganizacionesSF] TO [CertificacionesServicios]
GRANT SELECT ON  [dbo].[vwrOrganizacionesSF] TO [Direcciones De Nivel]
GRANT SELECT ON  [dbo].[vwrOrganizacionesSF] TO [GestionInstitucional]
GRANT SELECT ON  [dbo].[vwrOrganizacionesSF] TO [Juntas]
GRANT SELECT ON  [dbo].[vwrOrganizacionesSF] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vwrOrganizacionesSF] TO [public]
GRANT SELECT ON  [dbo].[vwrOrganizacionesSF] TO [SoloVer]
GO
